/* Get rid of the old user if they are there */
PRINT ''
use ReTS_Db
GO

PRINT ''
PRINT 'Setting up defaut Assassin user and login'
if USER_ID('RetsUser') is not null
    exec sp_dropuser 'RetsUser'
GO

if exists ( select * from master.dbo.syslogins where loginname = 'RetsUser' )
    exec sp_droplogin 'RetsUser'
GO

/* Re-add the user */
exec sp_addlogin 'RetsUser','pwd4retsuser!', 'ReTS_Db'
GO

exec sp_grantdbaccess 'RetsUser'
GO

exec sp_addrolemember 'db_owner', 'RetsUser'
GO 